<html>
 <head>
  <link href="./leetcode-problem.css" rel="stylesheet" type="text/css">
 </head>
 <body>
  <div class="question_difficulty">
   难度：Easy
  </div>
  <div>
   <h1 class="question_title">
    197. Rising Temperature
   </h1>
   <p>
    Given a
    <code>
     Weather
    </code>
    table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.
   </p>
   <pre>
+---------+------------------+------------------+
| Id(INT) | RecordDate(DATE) | Temperature(INT) |
+---------+------------------+------------------+
|       1 |       2015-01-01 |               10 |
|       2 |       2015-01-02 |               25 |
|       3 |       2015-01-03 |               20 |
|       4 |       2015-01-04 |               30 |
+---------+------------------+------------------+
</pre>
   <p>
    For example, return the following Ids for the above
    <code>
     Weather
    </code>
    table:
   </p>
   <pre>
+----+
| Id |
+----+
|  2 |
|  4 |
+----+
</pre>
  </div>
  <div>
   <h1 class="question_title">
    197. 上升的温度
   </h1>
   <p>
    给定一个
    <code>
     Weather
    </code>
    表，编写一个 SQL 查询，来查找与之前（昨天的）日期相比温度更高的所有日期的 Id。
   </p>
   <pre>+---------+------------------+------------------+
| Id(INT) | RecordDate(DATE) | Temperature(INT) |
+---------+------------------+------------------+
|       1 |       2015-01-01 |               10 |
|       2 |       2015-01-02 |               25 |
|       3 |       2015-01-03 |               20 |
|       4 |       2015-01-04 |               30 |
+---------+------------------+------------------+</pre>
   <p>
    例如，根据上述给定的
    <code>
     Weather
    </code>
    表格，返回如下 Id:
   </p>
   <pre>+----+
| Id |
+----+
|  2 |
|  4 |
+----+</pre>
  </div>
 </body>
</html>